﻿CREATE TABLE [acms].[Email]
(
	[Id] int NOT NULL identity(1,1), 
	[UserId] int NULL,
	[EmailAddress] varchar(255),
	[Name] varchar(100),
	[FilePath] varchar(200) NOT NULL,
	[To] varchar(200) NULL,
	[Cc] varchar(200) NULL,
	[Bcc] varchar(200) NULL,
	[From] varchar(200) NULL,
	[ReplyTo] varchar(200) NULL,
	[Subject] varchar(200),
	[Body] varchar(2000),
	[Html] bit,
	[Created] Datetime NOT NULL,
	[Sent] DateTime,
	[Failed] bit NOT NULL,
	[ConcurencyId] rowversion
);
